<?xml version="1.0" encoding="UTF-8" ?>
<%
/***********************************************
* 파일명 : vacationExcel.jsp
* 기  능 : 휴가관리 - 휴가 엑셀 저장
* 최초 작성일 : 2009/10/23
* @author : Yang D
*************************************************/
%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib 	prefix="s" 		uri="/struts-tags"%>
<%
	response.setHeader("Content-Disposition", "attachment; filename=PHILERGYSYSTEM_vacation_excel.xls"); 
	//[출처] 간단하게 JSP로 Excel파일 생성하기(excel,엑셀) - 자바누리|작성자 비온디
 %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	
	<meta http-equiv="pragma" 			content="no-cache" />
	<meta http-equiv="cache-control" 	content="no-cache" />
	<meta http-equiv="expires" 			content="0" />
	
	<title></title>
</head>
<body>
	<table border="1">
		<tr>
			<td class="th_header" rowspan="2">그룹</td>
			<td class="th_header" rowspan="2">팀</td>
			<td class="th_header" rowspan="2">성명</td>
			
			
			<td class="th_header" rowspan="2">입사일</td>
			<td class="th_header" rowspan="2">재직<br/>여부</td>
			<td class="th_header" colspan="2" >휴가배정</td>

			<td class="th_header" colspan="3" >연차휴가</td>
			<td class="th_header" colspan="3">특별휴가</td>
			<td class="th_header" colspan="3">연차/특별휴가 합계</td>
			
			<td class="th_header" rowspan="2">경조<br/>휴가</td>
			<td class="th_header" rowspan="2">공가</td>
			<td class="th_header" rowspan="2">기타<br/>휴가</td>
			
			<td class="th_header" rowspan="2" style="font-weight: bold;color: #0000FF;">전체휴가<br />사용일수</td>
		</tr>
		<tr>
			<td class="th_header" >시작일</td>
			<td class="th_header" >종료일</td>
			
			<td class="th_header" >배정<br />일수</td>
			<td class="th_header" style="font-weight: bold;color: #0000FF;">사용<br />일수</td>
			<td class="th_header">잔여<br />일수</td>
			<td class="th_header">배정<br />일수</td>
			<td class="th_header" style="font-weight: bold;color: #0000FF;">사용<br />일수</td>
			<td class="th_header">잔여<br />일수</td>
			<td class="th_header">배정<br />일수</td>
			<td class="th_header" style="font-weight: bold;color: #0000FF;">사용<br />일수</td>
			<td class="th_header">잔여<br />일수</td>
		</tr>
     <s:iterator value="listVacationZ" >
		<s:iterator>
			<tr>
				<td><s:property value="group_nm"/></td>
				<td><s:property value="team_nm"	/></td>
				<td><s:property value="emp_nm"	/></td>
				<td><s:property value="apply_dt"	/></td>
				<td><s:property value="work_yn"	/></td>
				<td><s:property value="start_dt"	/></td>
				<td><s:property value="end_dt"	/></td>
				
				<td><s:property value="an_sum_total"	/></td>
				<td><s:property value="an_use_sum"	/></td>
				<td><s:property value="an_rest_sum"	/></td>
				
				<td><s:property value="sp_sum_total"		/></td>
				<td><s:property value="sp_use_sum"		/></td>
				<td><s:property value="sp_rest_sum"		/></td>
				
				<td><s:property value="an_sp_sum_total"	/></td>
				<td><s:property value="an_sp_use_sum"	/></td>
				<td><s:property value="an_sp_rest_sum"	/></td>
				<td><s:property value="bc_use_sum"	/></td>
				<td><s:property value="pb_use_sum"		/></td>
				<td><s:property value="etc_use_sum"	/></td>
				
				<td><s:property value="use_total"	/></td>
			</tr>
		</s:iterator>
    </s:iterator>
	</table>	
</body>
</html>